package com.ruoyi.biz.letter.mapper;

import java.util.List;

import com.ruoyi.biz.letter.domain.BizMessageBoard;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.biz.report.letter.vo.*;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

/**
 * 人民网留言板Mapper接口
 *
 * @author Fei.Cong
 * @date 2024-07-18
 */
@Mapper
public interface BizMessageBoardMapper extends BaseMapper<BizMessageBoard> {

    IPage<BizMessageBoard> selectPageList(IPage<BizMessageBoard> page, @Param("entity") BizMessageBoard bizMessageBoard);

    List<ReportCityCategoryResp> selectReportGroupCityAndCategory(@Param("entity") CategoryReportReq reportReq);

    List<ReportYearCityResp> selectReportGroupMonthAndOwnerArea(@Param("entity") CategoryReportReq reportReq);

    List<ReportYearCategoryResp> selectReportGroupMonthAndCategory(@Param("entity") CategoryReportReq reportReq);

    List<CategoryCount> selectReportGroupCategory(@Param("currentMonth") String currentMonth);

}
